package com.yxuan.springboot.mapper;


import com.yxuan.springboot.model.ProfessionalScore;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 
 * @author zchao
 *    ProfessionalScoreMapper层
 * @date 2023-06-06 16:22:17
 */

@Mapper
public interface ProfessionalScoreMapper extends BaseMapper<ProfessionalScore> {


    List<String> findAllYears(@Param("professionalName")String professionalName, @Param("schoolId") Integer schoolId, @Param("province") String province, @Param("classification")String Classification) throws Exception;

    ProfessionalScore findTargetProfession(@Param("professionalName")String professionalName, @Param("schoolId") Integer schoolId, @Param("province") String province, @Param("classification")String Classification,@Param("year") String targetYear) throws Exception;

    List<ProfessionalScore> findTargetByParams(@Param("lowestOrder") String lowestOrder, @Param("enrollmentYear") List enrollmentYear, @Param("provinceName") String provinceName, @Param("specialityClassification") List<String> specialityClassification, @Param("rankOneUp") String rankOneUp, @Param("rankOneLow") String rankOneLow);

    List<ProfessionalScore> findProfeesionByIdAndProfessionName(@Param("provinceName") String provinceName, @Param("schoolId") Long schoolId, @Param("professionalName") List professionalName);
}
